/*
 Navicat Premium Data Transfer

 Source Server         : test
 Source Server Type    : MySQL
 Source Server Version : 50621
 Source Host           : localhost
 Source Database       : resourceplatform

 Target Server Type    : MySQL
 Target Server Version : 50621
 File Encoding         : utf-8

 Date: 11/05/2014 15:25:37 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `authorities`
-- ----------------------------
DROP TABLE IF EXISTS `authorities`;
CREATE TABLE `authorities` (
  `username` varchar(50) NOT NULL,
  `authority` varchar(50) NOT NULL,
  UNIQUE KEY `authorities_idx_1` (`username`,`authority`),
  CONSTRAINT `authorities_ibfk_1` FOREIGN KEY (`username`) REFERENCES `users` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `authorities`
-- ----------------------------
BEGIN;
INSERT INTO `authorities` VALUES ('roy', 'USER'), ('test', 'USER'), ('test@123.com', 'BUSINESS'), ('user', 'USER'), ('xbk@163.com', 'BUSINESS'), ('xinbake@123.com', 'BUSINESS'), ('xinbakexixi@163.com', 'BUSINESS');
COMMIT;

-- ----------------------------
--  Table structure for `banned_user`
-- ----------------------------
DROP TABLE IF EXISTS `banned_user`;
CREATE TABLE `banned_user` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `chat_room_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `user_id` varchar(255) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_banned_user_1` (`chat_room_id`),
  KEY `fk_banned_user_2` (`user_id`),
  CONSTRAINT `fk_banned_user_1` FOREIGN KEY (`chat_room_id`) REFERENCES `chat_room` (`id`),
  CONSTRAINT `fk_banned_user_2` FOREIGN KEY (`user_id`) REFERENCES `end_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `business_resource`
-- ----------------------------
DROP TABLE IF EXISTS `business_resource`;
CREATE TABLE `business_resource` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `hash_value` varchar(255) COLLATE utf8_bin NOT NULL,
  `business_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `uploader_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `upload_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `class_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_business_resource` (`hash_value`),
  KEY `fk_business_resource_1` (`business_id`),
  KEY `fk_business_resource_2` (`class_id`),
  CONSTRAINT `fk_business_resource` FOREIGN KEY (`hash_value`) REFERENCES `resource` (`hash_value`),
  CONSTRAINT `fk_business_resource_1` FOREIGN KEY (`business_id`) REFERENCES `business_user` (`id`),
  CONSTRAINT `fk_business_resource_2` FOREIGN KEY (`class_id`) REFERENCES `resource_class` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Records of `business_resource`
-- ----------------------------
BEGIN;
INSERT INTO `business_resource` VALUES ('123', '123', '1', '123', 'ewt ', '2014-10-23 17:11:05', '1', 'ewt wet'), ('13', '123', '1', '12', '多个', '2014-10-23 14:24:38', '1', '个 艾丝凡');
COMMIT;

-- ----------------------------
--  Table structure for `business_user`
-- ----------------------------
DROP TABLE IF EXISTS `business_user`;
CREATE TABLE `business_user` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `phone` decimal(13,0) DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `router` varchar(255) COLLATE utf8_bin NOT NULL,
  `parent` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `product_table_name` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '?????????',
  `password` varchar(255) COLLATE utf8_bin NOT NULL,
  `email` varchar(255) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Records of `business_user`
-- ----------------------------
BEGIN;
INSERT INTO `business_user` VALUES ('07e73f14-585f-495d-86f5-6da66233d009', '星巴克', '11765467324', '西湖温壶', '192.134.12.234', '', '2332441njkhjh', '$2a$10$D7jnHghRaYqmBtrMMxEKW.D3DF3SLLqMvsOcbxa1xDZ7Qf1SWV4e6', 'xinbake@123.com'), ('1', '是的', '1223224', '的', '发送到', null, '的双方各', '第四个', ''), ('32ebc8d4-2910-4ed3-b8e7-6c4ee6f337ab', '西湖', '11765467324', '西湖温壶', '192.134.12.234', '', '2332441njkhjh', '$2a$10$KP3QfCw9ZkSfs.LsRD9izOUy08GsYq7TqPb7ARDNCNWbIe/qKnxnm', 'test@123.com'), ('9aa50c92-8f37-48cc-a6b4-07ab28cb0a8c', '星巴克西溪店', '15658850533', '西溪路368号', '102.134.12.234', '', '85f33502-ea36-47e3-bc21-11d539a71eb8', '$2a$10$j1laGOisKz65GHbZe95GMeMTRgU1FDE4BJFeYrnkc4NT4oCbaAnU.', 'xinbakexixi@163.com'), ('b217cb94-c1d5-4483-aff6-490d265dfc02', '星巴克西溪店', '15658850533', '西溪路368号', '102.134.12.234', '', '6f1b68c8-4bd7-4b62-abd8-05c7567e29e2', '$2a$10$YZSEPERxt7cbkhJfCbmhwuUmies6DXA/lbcQw4zWSbO3VlEtr787e', 'xbk@163.com');
COMMIT;

-- ----------------------------
--  Table structure for `chat_record`
-- ----------------------------
DROP TABLE IF EXISTS `chat_record`;
CREATE TABLE `chat_record` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `from` varchar(255) COLLATE utf8_bin NOT NULL,
  `to` varchar(255) COLLATE utf8_bin NOT NULL,
  `content` text COLLATE utf8_bin NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `chat_room`
-- ----------------------------
DROP TABLE IF EXISTS `chat_room`;
CREATE TABLE `chat_room` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `business_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `limit` int(11) DEFAULT NULL,
  `violation_base` int(11) DEFAULT NULL COMMENT '???????????????????',
  PRIMARY KEY (`id`),
  KEY `fk_chat_room` (`business_id`),
  CONSTRAINT `fk_chat_room` FOREIGN KEY (`business_id`) REFERENCES `business_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `coupon`
-- ----------------------------
DROP TABLE IF EXISTS `coupon`;
CREATE TABLE `coupon` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `business_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `quato` int(11) DEFAULT NULL,
  `base` int(11) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_coupon` (`business_id`),
  CONSTRAINT `fk_coupon` FOREIGN KEY (`business_id`) REFERENCES `business_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `coupon_record`
-- ----------------------------
DROP TABLE IF EXISTS `coupon_record`;
CREATE TABLE `coupon_record` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `coupon_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `used_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_coupon_record_1` (`coupon_id`),
  KEY `fk_coupon_record_2` (`user_id`),
  CONSTRAINT `fk_coupon_record_1` FOREIGN KEY (`coupon_id`) REFERENCES `coupon` (`id`),
  CONSTRAINT `fk_coupon_record_2` FOREIGN KEY (`user_id`) REFERENCES `end_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `end_user`
-- ----------------------------
DROP TABLE IF EXISTS `end_user`;
CREATE TABLE `end_user` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `password` varchar(255) COLLATE utf8_bin NOT NULL,
  `email` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `enabled` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Records of `end_user`
-- ----------------------------
BEGIN;
INSERT INTO `end_user` VALUES ('ffff', 'hhhu', 'huhuh', 'uhu', 'huh', null);
COMMIT;

-- ----------------------------
--  Table structure for `filter_user`
-- ----------------------------
DROP TABLE IF EXISTS `filter_user`;
CREATE TABLE `filter_user` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `chat_room_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `sql` text COLLATE utf8_bin,
  `name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '?????',
  PRIMARY KEY (`id`),
  KEY `fk_filter_user` (`chat_room_id`),
  CONSTRAINT `fk_filter_user` FOREIGN KEY (`chat_room_id`) REFERENCES `chat_room` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `filter_word`
-- ----------------------------
DROP TABLE IF EXISTS `filter_word`;
CREATE TABLE `filter_word` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `chat_room_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `content` varchar(255) COLLATE utf8_bin NOT NULL,
  `type` bit(1) DEFAULT b'0' COMMENT '0?keyword?1?sensitiveword',
  PRIMARY KEY (`id`),
  KEY `fk_filter_word` (`chat_room_id`),
  CONSTRAINT `fk_filter_word` FOREIGN KEY (`chat_room_id`) REFERENCES `chat_room` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `foot_print`
-- ----------------------------
DROP TABLE IF EXISTS `foot_print`;
CREATE TABLE `foot_print` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `user_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `in_time` timestamp NULL DEFAULT NULL,
  `business_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_foot_print_1` (`user_id`),
  KEY `fk_foot_print_2` (`business_id`),
  CONSTRAINT `fk_foot_print_1` FOREIGN KEY (`user_id`) REFERENCES `end_user` (`id`),
  CONSTRAINT `fk_foot_print_2` FOREIGN KEY (`business_id`) REFERENCES `business_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `member_point`
-- ----------------------------
DROP TABLE IF EXISTS `member_point`;
CREATE TABLE `member_point` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `business_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `user_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `point` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `business_id` (`business_id`),
  CONSTRAINT `member_point_ibfk_1` FOREIGN KEY (`business_id`) REFERENCES `banned_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `member_point_change`
-- ----------------------------
DROP TABLE IF EXISTS `member_point_change`;
CREATE TABLE `member_point_change` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL,
  `mem_point_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `change` int(11) NOT NULL,
  `reason` varchar(255) COLLATE utf8_bin NOT NULL,
  KEY `mem_point_id` (`mem_point_id`),
  CONSTRAINT `member_point_change_ibfk_1` FOREIGN KEY (`mem_point_id`) REFERENCES `member_point` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `meta_field`
-- ----------------------------
DROP TABLE IF EXISTS `meta_field`;
CREATE TABLE `meta_field` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL,
  `table_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '??????id??????business_users?product_table_id\\???id?',
  `name` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '????',
  `type` enum('INT','VARCHAR') COLLATE utf8_bin NOT NULL,
  `constraint` bit(8) NOT NULL COMMENT '????????????????????????????????8?',
  `length` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `oauth_access_token`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_access_token`;
CREATE TABLE `oauth_access_token` (
  `token_id` varchar(256) DEFAULT NULL,
  `token` blob,
  `authentication_id` varchar(256) DEFAULT NULL,
  `user_name` varchar(256) DEFAULT NULL,
  `client_id` varchar(256) DEFAULT NULL,
  `authentication` blob,
  `refresh_token` varchar(256) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `oauth_access_token`
-- ----------------------------
BEGIN;
INSERT INTO `oauth_access_token` VALUES ('761a5bbac2c42d624f1cb371309b8ba0', 0xaced0005737200436f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f4175746832416363657373546f6b656e0cb29e361b24face0200064c00156164646974696f6e616c496e666f726d6174696f6e74000f4c6a6176612f7574696c2f4d61703b4c000a65787069726174696f6e7400104c6a6176612f7574696c2f446174653b4c000c72656672657368546f6b656e74003f4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f636f6d6d6f6e2f4f417574683252656672657368546f6b656e3b4c000573636f706574000f4c6a6176612f7574696c2f5365743b4c0009746f6b656e547970657400124c6a6176612f6c616e672f537472696e673b4c000576616c756571007e000578707372001e6a6176612e7574696c2e436f6c6c656374696f6e7324456d7074794d6170593614855adce7d002000078707372000e6a6176612e7574696c2e44617465686a81014b597419030000787077080000014971f8b7167870737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c0001637400164c6a6176612f7574696c2f436f6c6c656374696f6e3b7870737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f400000000000027400047265616474000577726974657874000662656172657274002438373365656235652d633238372d343634612d396236622d636633313130393735363663, '3a467ad52b818b71522d3645f565bb9e', 'user', 'clientapp', 0xaced0005737200416f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f417574683241757468656e7469636174696f6ebd400b02166252130200024c000d73746f7265645265717565737474003c4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f4f4175746832526571756573743b4c00127573657241757468656e7469636174696f6e7400324c6f72672f737072696e676672616d65776f726b2f73656375726974792f636f72652f41757468656e7469636174696f6e3b787200476f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e416273747261637441757468656e7469636174696f6e546f6b656ed3aa287e6e47640e0200035a000d61757468656e746963617465644c000b617574686f7269746965737400164c6a6176612f7574696c2f436f6c6c656374696f6e3b4c000764657461696c737400124c6a6176612f6c616e672f4f626a6563743b787000737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c6973747400104c6a6176612f7574696c2f4c6973743b7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c00016371007e00047870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a65787000000001770400000001737200426f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e617574686f726974792e53696d706c654772616e746564417574686f7269747900000000000001400200014c0004726f6c657400124c6a6176612f6c616e672f537472696e673b7870740004555345527871007e000c707372003a6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f41757468325265717565737400000000000000010200065a0008617070726f7665644c000b617574686f72697469657371007e00044c000a657874656e73696f6e7374000f4c6a6176612f7574696c2f4d61703b4c000b726564697265637455726971007e000e4c000b7265736f7572636549647374000f4c6a6176612f7574696c2f5365743b4c000d726573706f6e7365547970657371007e0013787200386f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e426173655265717565737436287a3ea37169bd0200034c0008636c69656e74496471007e000e4c001172657175657374506172616d657465727371007e00124c000573636f706571007e00137870740009636c69656e74617070737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00127870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c77080000001000000004740008757365726e616d657400047573657274000d636c69656e745f73656372657474000631323334353674000a6772616e745f7479706574000870617373776f7264740009636c69656e745f6964740009636c69656e7461707078737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007871007e0009737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f4000000000000274000472656164740005777269746578017371007e0026770c000000103f400000000000017371007e000d74000455534552787371007e00193f40000000000010770800000010000000007870707371007e0026770c000000003f40000000000000787372004f6f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e557365726e616d6550617373776f726441757468656e7469636174696f6e546f6b656e00000000000001400200024c000b63726564656e7469616c7371007e00054c00097072696e636970616c71007e00057871007e0003017371007e00077371007e000b0000000177040000000171007e000f7871007e00327070737200326f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e7573657264657461696c732e5573657200000000000001400200075a00116163636f756e744e6f6e457870697265645a00106163636f756e744e6f6e4c6f636b65645a001563726564656e7469616c734e6f6e457870697265645a0007656e61626c65644c000b617574686f72697469657371007e00134c000870617373776f726471007e000e4c0008757365726e616d6571007e000e7870010101017371007e0023737200116a6176612e7574696c2e54726565536574dd98509395ed875b0300007870737200466f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e7573657264657461696c732e5573657224417574686f72697479436f6d70617261746f720000000000000140020000787077040000000171007e000f787074000475736572, null), ('a1e00e3bb3e1ba7f035f9cc9f464e4dc', 0xaced0005737200436f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f4175746832416363657373546f6b656e0cb29e361b24face0200064c00156164646974696f6e616c496e666f726d6174696f6e74000f4c6a6176612f7574696c2f4d61703b4c000a65787069726174696f6e7400104c6a6176612f7574696c2f446174653b4c000c72656672657368546f6b656e74003f4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f636f6d6d6f6e2f4f417574683252656672657368546f6b656e3b4c000573636f706574000f4c6a6176612f7574696c2f5365743b4c0009746f6b656e547970657400124c6a6176612f6c616e672f537472696e673b4c000576616c756571007e000578707372001e6a6176612e7574696c2e436f6c6c656374696f6e7324456d7074794d6170593614855adce7d002000078707372000e6a6176612e7574696c2e44617465686a81014b597419030000787077080000014976ba7af07870737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c0001637400164c6a6176612f7574696c2f436f6c6c656374696f6e3b7870737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f400000000000027400047265616474000577726974657874000662656172657274002433613865626538352d613730622d343533302d613930302d613564383136316632653830, '42fd3a2b36c0309816e947db9106ec6a', 'user', 'test', 0xaced0005737200416f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f417574683241757468656e7469636174696f6ebd400b02166252130200024c000d73746f7265645265717565737474003c4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f4f4175746832526571756573743b4c00127573657241757468656e7469636174696f6e7400324c6f72672f737072696e676672616d65776f726b2f73656375726974792f636f72652f41757468656e7469636174696f6e3b787200476f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e416273747261637441757468656e7469636174696f6e546f6b656ed3aa287e6e47640e0200035a000d61757468656e746963617465644c000b617574686f7269746965737400164c6a6176612f7574696c2f436f6c6c656374696f6e3b4c000764657461696c737400124c6a6176612f6c616e672f4f626a6563743b787000737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c6973747400104c6a6176612f7574696c2f4c6973743b7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c00016371007e00047870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a65787000000001770400000001737200426f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e617574686f726974792e53696d706c654772616e746564417574686f7269747900000000000001400200014c0004726f6c657400124c6a6176612f6c616e672f537472696e673b7870740004555345527871007e000c707372003a6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f41757468325265717565737400000000000000010200065a0008617070726f7665644c000b617574686f72697469657371007e00044c000a657874656e73696f6e7374000f4c6a6176612f7574696c2f4d61703b4c000b726564697265637455726971007e000e4c000b7265736f7572636549647374000f4c6a6176612f7574696c2f5365743b4c000d726573706f6e7365547970657371007e0013787200386f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e426173655265717565737436287a3ea37169bd0200034c0008636c69656e74496471007e000e4c001172657175657374506172616d657465727371007e00124c000573636f706571007e0013787074000474657374737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00127870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c77080000001000000002740008757365726e616d657400047573657274000a6772616e745f7479706574000870617373776f726478737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007871007e0009737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f4000000000000274000472656164740005777269746578017371007e0022770c000000103f400000000000017371007e000d74000455534552787371007e00193f40000000000010770800000010000000007870707371007e0022770c000000003f40000000000000787372004f6f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e557365726e616d6550617373776f726441757468656e7469636174696f6e546f6b656e00000000000001400200024c000b63726564656e7469616c7371007e00054c00097072696e636970616c71007e00057871007e0003017371007e00077371007e000b0000000177040000000171007e000f7871007e002e7070737200326f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e7573657264657461696c732e5573657200000000000001400200075a00116163636f756e744e6f6e457870697265645a00106163636f756e744e6f6e4c6f636b65645a001563726564656e7469616c734e6f6e457870697265645a0007656e61626c65644c000b617574686f72697469657371007e00134c000870617373776f726471007e000e4c0008757365726e616d6571007e000e7870010101017371007e001f737200116a6176612e7574696c2e54726565536574dd98509395ed875b0300007870737200466f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e7573657264657461696c732e5573657224417574686f72697479436f6d70617261746f720000000000000140020000787077040000000171007e000f787074000475736572, null), ('d28b7232f26e5ed532361487b9656d5f', 0xaced0005737200436f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f4175746832416363657373546f6b656e0cb29e361b24face0200064c00156164646974696f6e616c496e666f726d6174696f6e74000f4c6a6176612f7574696c2f4d61703b4c000a65787069726174696f6e7400104c6a6176612f7574696c2f446174653b4c000c72656672657368546f6b656e74003f4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f636f6d6d6f6e2f4f417574683252656672657368546f6b656e3b4c000573636f706574000f4c6a6176612f7574696c2f5365743b4c0009746f6b656e547970657400124c6a6176612f6c616e672f537472696e673b4c000576616c756571007e000578707372001e6a6176612e7574696c2e436f6c6c656374696f6e7324456d7074794d6170593614855adce7d002000078707372000e6a6176612e7574696c2e44617465686a81014b59741903000078707708000001497cdb81567870737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c0001637400164c6a6176612f7574696c2f436f6c6c656374696f6e3b7870737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f400000000000027400047265616474000577726974657874000662656172657274002461663762356336622d376538332d343665662d613834352d396263393661393166636461, 'aa99c553b111f9e9383df8ebb9cd7bb6', 'roy', 'clientapp', 0xaced0005737200416f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f417574683241757468656e7469636174696f6ebd400b02166252130200024c000d73746f7265645265717565737474003c4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f4f4175746832526571756573743b4c00127573657241757468656e7469636174696f6e7400324c6f72672f737072696e676672616d65776f726b2f73656375726974792f636f72652f41757468656e7469636174696f6e3b787200476f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e416273747261637441757468656e7469636174696f6e546f6b656ed3aa287e6e47640e0200035a000d61757468656e746963617465644c000b617574686f7269746965737400164c6a6176612f7574696c2f436f6c6c656374696f6e3b4c000764657461696c737400124c6a6176612f6c616e672f4f626a6563743b787000737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c6973747400104c6a6176612f7574696c2f4c6973743b7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c00016371007e00047870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a65787000000001770400000001737200426f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e617574686f726974792e53696d706c654772616e746564417574686f7269747900000000000001400200014c0004726f6c657400124c6a6176612f6c616e672f537472696e673b7870740009524f4c455f555345527871007e000c707372003a6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f41757468325265717565737400000000000000010200065a0008617070726f7665644c000b617574686f72697469657371007e00044c000a657874656e73696f6e7374000f4c6a6176612f7574696c2f4d61703b4c000b726564697265637455726971007e000e4c000b7265736f7572636549647374000f4c6a6176612f7574696c2f5365743b4c000d726573706f6e7365547970657371007e0013787200386f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e426173655265717565737436287a3ea37169bd0200034c0008636c69656e74496471007e000e4c001172657175657374506172616d657465727371007e00124c000573636f706571007e00137870740009636c69656e74617070737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00127870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c77080000001000000002740008757365726e616d65740003726f7974000a6772616e745f7479706574000870617373776f726478737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007871007e0009737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f4000000000000274000472656164740005777269746578017371007e0022770c000000103f400000000000027371007e000d740008425553494e4553537371007e000d74000455534552787371007e00193f40000000000010770800000010000000007870707371007e0022770c000000003f40000000000000787372004f6f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e557365726e616d6550617373776f726441757468656e7469636174696f6e546f6b656e00000000000001400200024c000b63726564656e7469616c7371007e00054c00097072696e636970616c71007e00057871007e0003017371007e00077371007e000b0000000177040000000171007e000f7871007e00307070737200326f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e7573657264657461696c732e5573657200000000000001400200075a00116163636f756e744e6f6e457870697265645a00106163636f756e744e6f6e4c6f636b65645a001563726564656e7469616c734e6f6e457870697265645a0007656e61626c65644c000b617574686f72697469657371007e00134c000870617373776f726471007e000e4c0008757365726e616d6571007e000e7870010101017371007e001f737200116a6176612e7574696c2e54726565536574dd98509395ed875b0300007870737200466f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e7573657264657461696c732e5573657224417574686f72697479436f6d70617261746f720000000000000140020000787077040000000171007e000f7870740003726f79, null), ('dbdeae2113a39a8ba5e873abdebb1bb9', 0xaced0005737200436f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f4175746832416363657373546f6b656e0cb29e361b24face0200064c00156164646974696f6e616c496e666f726d6174696f6e74000f4c6a6176612f7574696c2f4d61703b4c000a65787069726174696f6e7400104c6a6176612f7574696c2f446174653b4c000c72656672657368546f6b656e74003f4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f636f6d6d6f6e2f4f417574683252656672657368546f6b656e3b4c000573636f706574000f4c6a6176612f7574696c2f5365743b4c0009746f6b656e547970657400124c6a6176612f6c616e672f537472696e673b4c000576616c756571007e000578707372001e6a6176612e7574696c2e436f6c6c656374696f6e7324456d7074794d6170593614855adce7d002000078707372000e6a6176612e7574696c2e44617465686a81014b59741903000078707708000001498d019b457870737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c0001637400164c6a6176612f7574696c2f436f6c6c656374696f6e3b7870737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f400000000000027400047265616474000577726974657874000662656172657274002437616132653332642d393032312d343364632d623965322d346566663631306339376631, 'c9f11f8e95b651e4a540e892b88e442b', 'roy', 'web', 0xaced0005737200416f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f417574683241757468656e7469636174696f6ebd400b02166252130200024c000d73746f7265645265717565737474003c4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f4f4175746832526571756573743b4c00127573657241757468656e7469636174696f6e7400324c6f72672f737072696e676672616d65776f726b2f73656375726974792f636f72652f41757468656e7469636174696f6e3b787200476f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e416273747261637441757468656e7469636174696f6e546f6b656ed3aa287e6e47640e0200035a000d61757468656e746963617465644c000b617574686f7269746965737400164c6a6176612f7574696c2f436f6c6c656374696f6e3b4c000764657461696c737400124c6a6176612f6c616e672f4f626a6563743b787000737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c6973747400104c6a6176612f7574696c2f4c6973743b7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c00016371007e00047870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a65787000000001770400000001737200426f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e617574686f726974792e53696d706c654772616e746564417574686f7269747900000000000001400200014c0004726f6c657400124c6a6176612f6c616e672f537472696e673b7870740004555345527871007e000c707372003a6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f41757468325265717565737400000000000000010200065a0008617070726f7665644c000b617574686f72697469657371007e00044c000a657874656e73696f6e7374000f4c6a6176612f7574696c2f4d61703b4c000b726564697265637455726971007e000e4c000b7265736f7572636549647374000f4c6a6176612f7574696c2f5365743b4c000d726573706f6e7365547970657371007e0013787200386f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e426173655265717565737436287a3ea37169bd0200034c0008636c69656e74496471007e000e4c001172657175657374506172616d657465727371007e00124c000573636f706571007e00137870740003776562737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00127870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c77080000001000000002740008757365726e616d65740003726f7974000a6772616e745f7479706574000870617373776f726478737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007871007e0009737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f4000000000000274000472656164740005777269746578017371007e0022770c000000103f400000000000017371007e000d74000455534552787371007e00193f40000000000010770800000010000000007870707371007e0022770c000000003f40000000000000787372004f6f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e557365726e616d6550617373776f726441757468656e7469636174696f6e546f6b656e00000000000001400200024c000b63726564656e7469616c7371007e00054c00097072696e636970616c71007e00057871007e0003017371007e00077371007e000b0000000177040000000171007e000f7871007e002e7070737200326f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e7573657264657461696c732e5573657200000000000001400200075a00116163636f756e744e6f6e457870697265645a00106163636f756e744e6f6e4c6f636b65645a001563726564656e7469616c734e6f6e457870697265645a0007656e61626c65644c000b617574686f72697469657371007e00134c000870617373776f726471007e000e4c0008757365726e616d6571007e000e7870010101017371007e001f737200116a6176612e7574696c2e54726565536574dd98509395ed875b0300007870737200466f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e7573657264657461696c732e5573657224417574686f72697479436f6d70617261746f720000000000000140020000787077040000000171007e000f7870740003726f79, null), ('bdb799cff7c06e097db6db596dfcc902', 0xaced0005737200436f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f4175746832416363657373546f6b656e0cb29e361b24face0200064c00156164646974696f6e616c496e666f726d6174696f6e74000f4c6a6176612f7574696c2f4d61703b4c000a65787069726174696f6e7400104c6a6176612f7574696c2f446174653b4c000c72656672657368546f6b656e74003f4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f636f6d6d6f6e2f4f417574683252656672657368546f6b656e3b4c000573636f706574000f4c6a6176612f7574696c2f5365743b4c0009746f6b656e547970657400124c6a6176612f6c616e672f537472696e673b4c000576616c756571007e000578707372001e6a6176612e7574696c2e436f6c6c656374696f6e7324456d7074794d6170593614855adce7d002000078707372000e6a6176612e7574696c2e44617465686a81014b59741903000078707708000001498ddc80497870737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c0001637400164c6a6176612f7574696c2f436f6c6c656374696f6e3b7870737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f400000000000027400047265616474000577726974657874000662656172657274002461333733326136352d616538332d346533372d383132622d323230653931333631313032, 'df005568f597e4c561604c4e07c1f1a9', 'xinbakexixi@163.com', 'web', 0xaced0005737200416f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f417574683241757468656e7469636174696f6ebd400b02166252130200024c000d73746f7265645265717565737474003c4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f4f4175746832526571756573743b4c00127573657241757468656e7469636174696f6e7400324c6f72672f737072696e676672616d65776f726b2f73656375726974792f636f72652f41757468656e7469636174696f6e3b787200476f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e416273747261637441757468656e7469636174696f6e546f6b656ed3aa287e6e47640e0200035a000d61757468656e746963617465644c000b617574686f7269746965737400164c6a6176612f7574696c2f436f6c6c656374696f6e3b4c000764657461696c737400124c6a6176612f6c616e672f4f626a6563743b787000737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c6973747400104c6a6176612f7574696c2f4c6973743b7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c00016371007e00047870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a65787000000001770400000001737200426f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e617574686f726974792e53696d706c654772616e746564417574686f7269747900000000000001400200014c0004726f6c657400124c6a6176612f6c616e672f537472696e673b7870740008425553494e4553537871007e000c707372003a6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f41757468325265717565737400000000000000010200065a0008617070726f7665644c000b617574686f72697469657371007e00044c000a657874656e73696f6e7374000f4c6a6176612f7574696c2f4d61703b4c000b726564697265637455726971007e000e4c000b7265736f7572636549647374000f4c6a6176612f7574696c2f5365743b4c000d726573706f6e7365547970657371007e0013787200386f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e426173655265717565737436287a3ea37169bd0200034c0008636c69656e74496471007e000e4c001172657175657374506172616d657465727371007e00124c000573636f706571007e00137870740003776562737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00127870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c77080000001000000002740008757365726e616d6574001378696e62616b6578697869403136332e636f6d74000a6772616e745f7479706574000870617373776f726478737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007871007e0009737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f4000000000000274000472656164740005777269746578017371007e0022770c000000103f400000000000017371007e000d74000455534552787371007e00193f40000000000010770800000010000000007870707371007e0022770c000000003f40000000000000787372004f6f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e557365726e616d6550617373776f726441757468656e7469636174696f6e546f6b656e00000000000001400200024c000b63726564656e7469616c7371007e00054c00097072696e636970616c71007e00057871007e0003017371007e00077371007e000b0000000177040000000171007e000f7871007e002e7070737200326f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e7573657264657461696c732e5573657200000000000001400200075a00116163636f756e744e6f6e457870697265645a00106163636f756e744e6f6e4c6f636b65645a001563726564656e7469616c734e6f6e457870697265645a0007656e61626c65644c000b617574686f72697469657371007e00134c000870617373776f726471007e000e4c0008757365726e616d6571007e000e7870010101017371007e001f737200116a6176612e7574696c2e54726565536574dd98509395ed875b0300007870737200466f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e7573657264657461696c732e5573657224417574686f72697479436f6d70617261746f720000000000000140020000787077040000000171007e000f787074001378696e62616b6578697869403136332e636f6d, null), ('dc2b6a0c9bb94a4b58c9ceb6729cfbe8', 0xaced0005737200436f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e636f6d6d6f6e2e44656661756c744f4175746832416363657373546f6b656e0cb29e361b24face0200064c00156164646974696f6e616c496e666f726d6174696f6e74000f4c6a6176612f7574696c2f4d61703b4c000a65787069726174696f6e7400104c6a6176612f7574696c2f446174653b4c000c72656672657368546f6b656e74003f4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f636f6d6d6f6e2f4f417574683252656672657368546f6b656e3b4c000573636f706574000f4c6a6176612f7574696c2f5365743b4c0009746f6b656e547970657400124c6a6176612f6c616e672f537472696e673b4c000576616c756571007e000578707372001e6a6176612e7574696c2e436f6c6c656374696f6e7324456d7074794d6170593614855adce7d002000078707372000e6a6176612e7574696c2e44617465686a81014b59741903000078707708000001498e4429e37870737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c0001637400164c6a6176612f7574696c2f436f6c6c656374696f6e3b7870737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f400000000000027400047265616474000577726974657874000662656172657274002432353230303331632d653238642d346165332d396462652d633332323266346363333331, '26483468be468d8cc8711a107b2e82fe', 'xinbake@123.com', 'web', 0xaced0005737200416f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f417574683241757468656e7469636174696f6ebd400b02166252130200024c000d73746f7265645265717565737474003c4c6f72672f737072696e676672616d65776f726b2f73656375726974792f6f61757468322f70726f76696465722f4f4175746832526571756573743b4c00127573657241757468656e7469636174696f6e7400324c6f72672f737072696e676672616d65776f726b2f73656375726974792f636f72652f41757468656e7469636174696f6e3b787200476f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e416273747261637441757468656e7469636174696f6e546f6b656ed3aa287e6e47640e0200035a000d61757468656e746963617465644c000b617574686f7269746965737400164c6a6176612f7574696c2f436f6c6c656374696f6e3b4c000764657461696c737400124c6a6176612f6c616e672f4f626a6563743b787000737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c6973747400104c6a6176612f7574696c2f4c6973743b7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c00016371007e00047870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a65787000000001770400000001737200426f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e617574686f726974792e53696d706c654772616e746564417574686f7269747900000000000001400200014c0004726f6c657400124c6a6176612f6c616e672f537472696e673b7870740008425553494e4553537871007e000c707372003a6f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e4f41757468325265717565737400000000000000010200065a0008617070726f7665644c000b617574686f72697469657371007e00044c000a657874656e73696f6e7374000f4c6a6176612f7574696c2f4d61703b4c000b726564697265637455726971007e000e4c000b7265736f7572636549647374000f4c6a6176612f7574696c2f5365743b4c000d726573706f6e7365547970657371007e0013787200386f72672e737072696e676672616d65776f726b2e73656375726974792e6f61757468322e70726f76696465722e426173655265717565737436287a3ea37169bd0200034c0008636c69656e74496471007e000e4c001172657175657374506172616d657465727371007e00124c000573636f706571007e00137870740003776562737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00127870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c77080000001000000002740008757365726e616d6574000f78696e62616b65403132332e636f6d74000a6772616e745f7479706574000870617373776f726478737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65536574801d92d18f9b80550200007871007e0009737200176a6176612e7574696c2e4c696e6b656448617368536574d86cd75a95dd2a1e020000787200116a6176612e7574696c2e48617368536574ba44859596b8b7340300007870770c000000103f4000000000000274000472656164740005777269746578017371007e0022770c000000103f400000000000017371007e000d74000455534552787371007e00193f40000000000010770800000010000000007870707371007e0022770c000000003f40000000000000787372004f6f72672e737072696e676672616d65776f726b2e73656375726974792e61757468656e7469636174696f6e2e557365726e616d6550617373776f726441757468656e7469636174696f6e546f6b656e00000000000001400200024c000b63726564656e7469616c7371007e00054c00097072696e636970616c71007e00057871007e0003017371007e00077371007e000b0000000177040000000171007e000f7871007e002e7070737200326f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e7573657264657461696c732e5573657200000000000001400200075a00116163636f756e744e6f6e457870697265645a00106163636f756e744e6f6e4c6f636b65645a001563726564656e7469616c734e6f6e457870697265645a0007656e61626c65644c000b617574686f72697469657371007e00134c000870617373776f726471007e000e4c0008757365726e616d6571007e000e7870010101017371007e001f737200116a6176612e7574696c2e54726565536574dd98509395ed875b0300007870737200466f72672e737072696e676672616d65776f726b2e73656375726974792e636f72652e7573657264657461696c732e5573657224417574686f72697479436f6d70617261746f720000000000000140020000787077040000000171007e000f787074000f78696e62616b65403132332e636f6d, null);
COMMIT;

-- ----------------------------
--  Table structure for `oauth_client_details`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_details`;
CREATE TABLE `oauth_client_details` (
  `client_id` varchar(255) NOT NULL,
  `resource_ids` varchar(256) DEFAULT NULL,
  `client_secret` varchar(256) DEFAULT NULL,
  `scope` varchar(256) DEFAULT NULL,
  `authorized_grant_types` varchar(256) DEFAULT NULL,
  `web_server_redirect_uri` varchar(256) DEFAULT NULL,
  `authorities` varchar(256) DEFAULT NULL,
  `access_token_validity` int(11) DEFAULT NULL,
  `refresh_token_validity` int(11) DEFAULT NULL,
  `additional_information` varchar(4096) DEFAULT NULL,
  `autoapprove` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `oauth_client_details`
-- ----------------------------
BEGIN;
INSERT INTO `oauth_client_details` VALUES ('android', 'restservice', '123456', 'read,write', 'password', null, 'USER', '259200', '129600', null, null), ('web', 'restservice', '123456', 'read,write', 'password', null, 'USER', '259200', '129600', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `oauth_client_token`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_token`;
CREATE TABLE `oauth_client_token` (
  `token_id` varchar(256) DEFAULT NULL,
  `token` blob,
  `authentication_id` varchar(256) DEFAULT NULL,
  `user_name` varchar(256) DEFAULT NULL,
  `client_id` varchar(256) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `oauth_code`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_code`;
CREATE TABLE `oauth_code` (
  `code` varchar(256) DEFAULT NULL,
  `authentication` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `oauth_refresh_token`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_refresh_token`;
CREATE TABLE `oauth_refresh_token` (
  `token_id` varchar(256) DEFAULT NULL,
  `token` blob,
  `authentication` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `order`
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL,
  `business_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `customer_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `costs` int(11) NOT NULL,
  `is_handled` bit(1) DEFAULT NULL COMMENT '?????????????',
  `is_paid` bit(1) DEFAULT NULL,
  `alarm_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_order_1` (`business_id`),
  KEY `fk_order_2` (`customer_id`),
  CONSTRAINT `fk_order_1` FOREIGN KEY (`business_id`) REFERENCES `business_user` (`id`),
  CONSTRAINT `fk_order_2` FOREIGN KEY (`customer_id`) REFERENCES `end_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `order_item`
-- ----------------------------
DROP TABLE IF EXISTS `order_item`;
CREATE TABLE `order_item` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `order_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `product_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `is_handled` bit(1) DEFAULT b'0',
  PRIMARY KEY (`id`),
  KEY `fk_order_item` (`order_id`),
  CONSTRAINT `fk_order_item` FOREIGN KEY (`order_id`) REFERENCES `order` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `order_reminder`
-- ----------------------------
DROP TABLE IF EXISTS `order_reminder`;
CREATE TABLE `order_reminder` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `order_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `count` int(11) DEFAULT NULL COMMENT '??????????',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '???????',
  PRIMARY KEY (`id`),
  KEY `fk_order_reminder` (`order_id`),
  CONSTRAINT `fk_order_reminder` FOREIGN KEY (`order_id`) REFERENCES `order` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='????????';

-- ----------------------------
--  Table structure for `order_rule`
-- ----------------------------
DROP TABLE IF EXISTS `order_rule`;
CREATE TABLE `order_rule` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `business_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `alarm_gap` int(11) DEFAULT NULL COMMENT ' ??????????????',
  `remind_gap` int(11) DEFAULT NULL COMMENT '??????????',
  `remind_max_count` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_order_rule` (`business_id`),
  CONSTRAINT `fk_order_rule` FOREIGN KEY (`business_id`) REFERENCES `business_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `platform_user`
-- ----------------------------
DROP TABLE IF EXISTS `platform_user`;
CREATE TABLE `platform_user` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `password` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `point_product`
-- ----------------------------
DROP TABLE IF EXISTS `point_product`;
CREATE TABLE `point_product` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `point_quato` int(11) NOT NULL COMMENT '???????',
  `exchange_amount` int(11) NOT NULL DEFAULT '0' COMMENT '???',
  `remain_amount` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '???',
  `business_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `description` text COLLATE utf8_bin,
  PRIMARY KEY (`id`),
  KEY `fk_point_product` (`business_id`),
  CONSTRAINT `fk_point_product` FOREIGN KEY (`business_id`) REFERENCES `business_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='??????????';

-- ----------------------------
--  Table structure for `product_class`
-- ----------------------------
DROP TABLE IF EXISTS `product_class`;
CREATE TABLE `product_class` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL,
  `business_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '??????????????',
  PRIMARY KEY (`id`),
  KEY `fk_product_class` (`business_id`),
  CONSTRAINT `fk_product_class` FOREIGN KEY (`business_id`) REFERENCES `business_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `promotion`
-- ----------------------------
DROP TABLE IF EXISTS `promotion`;
CREATE TABLE `promotion` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `start_time` timestamp NULL DEFAULT NULL COMMENT '?start_time?null????????????????????10?',
  `end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `participate_limit` int(11) DEFAULT NULL COMMENT '-1??????',
  `business_id` varchar(255) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_promotion` (`business_id`),
  CONSTRAINT `fk_promotion` FOREIGN KEY (`business_id`) REFERENCES `business_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='????????';

-- ----------------------------
--  Table structure for `promotion_progress`
-- ----------------------------
DROP TABLE IF EXISTS `promotion_progress`;
CREATE TABLE `promotion_progress` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `trigger_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `progress` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_promotion_progress_1` (`trigger_id`),
  KEY `fk_promotion_progress_2` (`user_id`),
  CONSTRAINT `fk_promotion_progress_1` FOREIGN KEY (`trigger_id`) REFERENCES `reward_trigger` (`id`),
  CONSTRAINT `fk_promotion_progress_2` FOREIGN KEY (`user_id`) REFERENCES `end_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `rank_list`
-- ----------------------------
DROP TABLE IF EXISTS `rank_list`;
CREATE TABLE `rank_list` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL,
  `business_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '???',
  `description` varchar(255) COLLATE utf8_bin NOT NULL,
  `is_public` bit(1) DEFAULT NULL,
  `view_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '????????',
  `upate_time` timestamp NULL DEFAULT NULL,
  `sql` text COLLATE utf8_bin,
  `type` enum('PRODUCT','RESOURCE') COLLATE utf8_bin DEFAULT NULL,
  `weight` int(11) DEFAULT NULL COMMENT '?????????',
  PRIMARY KEY (`id`),
  KEY `fk_rank_list` (`business_id`),
  CONSTRAINT `fk_rank_list` FOREIGN KEY (`business_id`) REFERENCES `business_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `resource`
-- ----------------------------
DROP TABLE IF EXISTS `resource`;
CREATE TABLE `resource` (
  `hash_value` varchar(255) COLLATE utf8_bin NOT NULL,
  `extension` varchar(255) COLLATE utf8_bin NOT NULL,
  `address` varchar(255) COLLATE utf8_bin NOT NULL,
  `size` decimal(15,0) NOT NULL,
  PRIMARY KEY (`hash_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Records of `resource`
-- ----------------------------
BEGIN;
INSERT INTO `resource` VALUES ('123', '额', '是', '12');
COMMIT;

-- ----------------------------
--  Table structure for `resource_class`
-- ----------------------------
DROP TABLE IF EXISTS `resource_class`;
CREATE TABLE `resource_class` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `business_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_resource_class` (`business_id`),
  CONSTRAINT `fk_resource_class` FOREIGN KEY (`business_id`) REFERENCES `business_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Records of `resource_class`
-- ----------------------------
BEGIN;
INSERT INTO `resource_class` VALUES ('1', '1', 'sdf');
COMMIT;

-- ----------------------------
--  Table structure for `resource_comment`
-- ----------------------------
DROP TABLE IF EXISTS `resource_comment`;
CREATE TABLE `resource_comment` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `user_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '?????',
  `content` text COLLATE utf8_bin NOT NULL COMMENT '????',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `business_resource_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `parent_comment_id` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '????????????',
  PRIMARY KEY (`id`),
  KEY `fk_resource_comment` (`business_resource_id`),
  KEY `fk_resource_comment_1` (`parent_comment_id`),
  KEY `fk_resource_comment_2` (`user_id`),
  CONSTRAINT `fk_resource_comment` FOREIGN KEY (`business_resource_id`) REFERENCES `business_resource` (`id`),
  CONSTRAINT `fk_resource_comment_1` FOREIGN KEY (`parent_comment_id`) REFERENCES `resource_comment` (`id`),
  CONSTRAINT `fk_resource_comment_2` FOREIGN KEY (`user_id`) REFERENCES `end_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `resource_download`
-- ----------------------------
DROP TABLE IF EXISTS `resource_download`;
CREATE TABLE `resource_download` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `user_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `resource_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_resource_download` (`user_id`),
  CONSTRAINT `fk_resource_download` FOREIGN KEY (`user_id`) REFERENCES `end_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `resource_vote`
-- ----------------------------
DROP TABLE IF EXISTS `resource_vote`;
CREATE TABLE `resource_vote` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `resource_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `user_id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0',
  `is_vote` bit(1) NOT NULL DEFAULT b'0' COMMENT '??????, 1???0??',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_resource_vote` (`resource_id`),
  KEY `fk_resource_vote_1` (`user_id`),
  CONSTRAINT `fk_resource_vote` FOREIGN KEY (`resource_id`) REFERENCES `business_resource` (`id`),
  CONSTRAINT `fk_resource_vote_1` FOREIGN KEY (`user_id`) REFERENCES `end_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `reward`
-- ----------------------------
DROP TABLE IF EXISTS `reward`;
CREATE TABLE `reward` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `type` enum('POINT','CASH_OFFSET','CASH_COUPON') COLLATE utf8_bin NOT NULL COMMENT '?????????????????????????????',
  `reward` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '??????????????id ??',
  `promotion_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_reward` (`promotion_id`),
  CONSTRAINT `fk_reward` FOREIGN KEY (`promotion_id`) REFERENCES `promotion` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `reward_trigger`
-- ----------------------------
DROP TABLE IF EXISTS `reward_trigger`;
CREATE TABLE `reward_trigger` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `type` enum('UPLOAD_TRAFFIC','DOWNLOAD_TRAFFIC','COST','RESOURCE_HEAT') COLLATE utf8_bin NOT NULL COMMENT '??????????????????????????????????',
  `benchmark` int(11) NOT NULL,
  `promotion_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_reward_tigger` (`promotion_id`),
  CONSTRAINT `fk_reward_tigger` FOREIGN KEY (`promotion_id`) REFERENCES `promotion` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `users`
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES ('roy', 'spring', '1'), ('test', '$2a$10$YzdCngpk.CPKSHhqardj5e1ytzjkfr64EJyCA8j/EF5iSIHhq/k.6', '1'), ('test@123.com', '$2a$10$8nXLCTT8sfP6i0.vE6tQJeslA/kRKa42NZZul8..uijn.ltx0i9Qu', '1'), ('user', '$2a$10$B9fuDKKnNmrIqnRn0Uu.WORwslWK4zRfILTWikSzPs5QVvzNdzFGe', '1'), ('xbk@163.com', '$2a$10$X6NOEjSDT/o7zmttGULoO.kYm9.5nUFPpjrZ2KKb5X61JpOb9dml.', '1'), ('xinbake@123.com', '$2a$10$j30vAvfGNoiUjvtR8tmYGeoYVTUafC5I9JmNyCDxpuD5nubEdToCe', '1'), ('xinbakexixi@163.com', '$2a$10$hweVScP.rRXEkeb4kZADqe9g/71C5vGp9VRE/VZ972O5tlbMtkrQ.', '1');
COMMIT;

-- ----------------------------
--  Table structure for `violation_record`
-- ----------------------------
DROP TABLE IF EXISTS `violation_record`;
CREATE TABLE `violation_record` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `chat_room_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `chat_record_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `user_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `sensitive_words` text COLLATE utf8_bin,
  PRIMARY KEY (`id`),
  KEY `fk_violation_record_1` (`chat_room_id`),
  KEY `fk_violation_record_2` (`chat_record_id`),
  KEY `fk_violation_record_3` (`user_id`),
  CONSTRAINT `fk_violation_record_1` FOREIGN KEY (`chat_room_id`) REFERENCES `chat_room` (`id`),
  CONSTRAINT `fk_violation_record_2` FOREIGN KEY (`chat_record_id`) REFERENCES `chat_record` (`id`),
  CONSTRAINT `fk_violation_record_3` FOREIGN KEY (`user_id`) REFERENCES `end_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

SET FOREIGN_KEY_CHECKS = 1;
